What is your Display Part of Field using an Access Query issue?
Responses:
How to: Display part of a date field using a calculated field
How to: Display part of a text field using a calculated field